package com.sj.stone.domain.oracle;

import com.sj.stone.domain.oracle.entry.Region;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface RegionRepository extends JpaRepository<Region, String> {

    @Query(value = "select t.* from ASS_REGIONS t where t.NAME like %?1%", nativeQuery = true)
    List<Region> findByName(String name);
}
